◀ Prev · Parts · Full · Next ▶

SQL Server Compact shares a common API with the other Microsoft SQL Server editions.cite-ref-lap1-4-0[4] It also includes ADO.NET providers for data access using ADO.NET APIs, and built-in synchronization capabilities,cite-ref-datasheet-2-2[2] as well as support for LINQ and Entity Framework. Future releases will unify the synchronization capabilities with Microsoft Synchronization Services.cite-ref-jad-5-0[5] Unlike other editions of Microsoft SQL Server, SQL CE runs in-processcite-ref-jad-5-1[5] with the application which is hosting it. It has a disk footprint of less than 2 MB and a memory footprint of approximately 5 MB.cite-ref-datasheet-2-3[2] SQL CE is optimized for an architecture where all applications share the same memory pool.cite-ref-new-6-0[6] Windows Store apps for Windows 8 cannot use SQL Server Compact edition, or any other edition of SQL Server.cite-ref-nossceonrt-7-0[7]

◀ Prev · Parts · Full · Next ▶